[dbo].[AsiNrdsMemberDemographic]

Property	Value
Created	3:53:48 PM Tuesday, November 22, 2011
Last Modified	11:40:00 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_AsiNrdsMemberDemographic: ID\SEQN$	ID	varchar(10)	10	('')
$Cluster Primary Key PK_AsiNrdsMemberDemographic: ID\SEQN$	SEQN	int	4	((0))
	Amount	varchar(9)	9	('')
	AssociationId	varchar(4)	4	('')
	Category	varchar(4)	4	('')
	Comment	varchar(80)	80	('')
	GroupCode	varchar(6)	6	('')
	MemberId	varchar(9)	9	('')
	Number	varchar(9)	9	('')
	PaymentCode	varchar(1)	1	('')
	PointOfEntry	varchar(9)	9	('')
	Status	varchar(4)	4	('')
	StatusDate	datetime	8
	NARTimestamp	varchar(20)	20	('')
	TIME_STAMP	timestamp	8

	Name	Columns	Unique
$Cluster Primary Key PK_AsiNrdsMemberDemographic: ID\SEQN$	PK_AsiNrdsMemberDemographic	ID, SEQN

SQL Script

CREATE TABLE [dbo].[AsiNrdsMemberDemographic]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_ID] DEFAULT (''),
[SEQN] [int] NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_SEQN] DEFAULT ((0)),
[Amount] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_Amount] DEFAULT (''),
[AssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_AssociationId] DEFAULT (''),
[Category] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_Category] DEFAULT (''),
[Comment] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_Comment] DEFAULT (''),
[GroupCode] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_GroupCode] DEFAULT (''),
[MemberId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_MemberId] DEFAULT (''),
[Number] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_Number] DEFAULT (''),
[PaymentCode] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_PaymentCode] DEFAULT (''),
[PointOfEntry] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_PointOfEntry] DEFAULT (''),
[Status] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_Status] DEFAULT (''),
[StatusDate] [datetime] NULL,
[NARTimestamp] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberDemographic_NARTimestamp] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsiNrdsMemberDemographic] ADD CONSTRAINT [PK_AsiNrdsMemberDemographic] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO